vb6 - Access Visual Studio 2008 server-based database from VB 6 project -


Is the VB-6 application accessible to a Visual Studio 2008-built server-based database? If not, what is the best way to share the database between VB-6 application and a C # application?

"post-text" itemprop = "text">

If you are referring to the SQL Server Express database that comes with Visual Studio 2008, you can access it with that Are there.

Connection strings to do this may most likely be one of the following:

  driver = {SQL Native Client}; Server = merserveadder; Database = myadabase; Uid = myUsername; PWD = mypassword;  

For SQL Server Express (that comes with VS2008), the server name syntax does not remember the Servername \ SQLEXPRESS where you replace the server name with the computer's name, where SQL Server 2005 Express is the home location of the installation.

The context for programming against SQL Server databases using ADO is here:

The example to connect to the SQL Server database is down (untested) Note that it is a Windows Authentication uses SQL Server authentication instead. Check your connection strings. If the SQL Native Client does not work, try one of the others

  'start the variable dim cn the new ADODB Specify the string 'OLE DB Provider as connection dial connection string. Cn.Provider = "{SQL Native Client}" 'Specify the connection string on the Open method ConnectionString = server = myMachineName \ SQLEXPRESS; Database = myDataBase; _UID = myUsername; Pwd = myPassword; Cn.Once Connection String  

Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -