Duplicate website, from SQL Server 2000 to 2005
I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory. The only difference will be that Godaddy has assigned it a sql server 2005 database. In respect to the connection string, is there a difference to how it should be typed? Im currently getting an error and not able to connect to the sql server 2005. This is my connection string -
Application("DSN") = "Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=XXXXX;Initial Catalog=AbcHomeInspector;Data Source=XXXXXXXXXXXXX"
I basically switched out/updated the Password, User ID, etc information and left all else as is. Can someone please help me with this. These are the only two lines of code which are different from website to website, as per the different user name, password, Data Sourse,etc...
Thank you very much,
It should be working with the same connection string from 2000 -> 2005.
What is the error message? Please update your question and include the error message!
Error connection to SQL Server 2014 via dotnet
I'm new into using Automations and dotnet, so i'm trying to learn (if I don't explain correct ). I'm trying to connect from NAV 2016 to an external SQL Server 2014 to read and post data to this.0 votes2 answersMads Morre3 months ago
vibratory bowl feeder
we provide quality viratory bowl feeders and we have many other machine which will give you idea, we are vibratory bowl feeder manufacture in pune and provide best services.0 votes1 answervibratory bowl feeder3 months ago
sql server tcp connection timed out
i have installed SQL server 2016 on a VPS that is running Win server 2016, i have enabled TCP/IC conectivity and made inbound rules for ports 1433,1434 and SQLSERV.exe.0 votes2 answersReza Deabae3 months ago
Study Guides or Test Sample for the position of Admin asst?
Study Guides or Test Sample for the position of Admin asst? I’m testing for administrative Asst in the civil service sector.So I’ve to take a test to MS Word and Excel. and it’s practical to test my abilities.0 votes5 answersLiza John3 months ago
Connect to Oracle using SqlSriverConnect
Fingers crossed someone can help. I am looking for a connection string to use in MS Access 2010 to connect to Oracle using SqlSriverConnect so that I can specify SQLDRIVERNOPROMPT. My attempts to format a connection string to date have been unsuccessful. Please accept my thanks in advance.0 votes3 answersDes Davies3 months ago
Connection String for a Hosted Database (Domain/Web hosting Provider) --- Windows Forms
I have domain name, and host account with a service provider. I want to host a sql server database through the service provider. I'm developing a windows forms application that I want to access this database. Whats the way to go with this situation?0 votes2 answersOageng Escobar Baruti3 months ago
Access 2010 to SQL server 2014 for updateable recordset
Trying to create an updatable form in Access 2010 connected to sql server 2014. I Don't want to use linked tables as many results will be provided by stored procedures. Using0 votes3 answersunknown4 months ago
ODBC attribute query
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N0 votes0 answersN M4 months ago
Accessing a mysql database from external host/ip? (ie: mysql workbench)
I have a mysql server running on x.x.x.x, and can access it internally no problem (of course). However when attempting to connect externally, ie using mysql workbench, or even from an external server, I get the error message "Host 'bla.bla.bla' is not allowed to connect to this MySQL server".0 votes0 answersJack Alex5 months ago
Error with ODBC Connection
I am getting error as below: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have installed the ODBC driver to connect to SQL server.0 votes1 answeruser5 months ago
- Load more posts