In Progress

SQL data connection problem

when connecting to my site I get

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/SFpool3/includes/[url removed, login to view], line 527

the common file code is

Opens the database connection (global variable 'DbConn').

'--------------------------------------------------------------------------

sub OpenDb()

dim isPhysicalPath

dim dbDir

set DbConn = [url removed, login to view]("ADODB.Connection" )

line527-----errorr [url removed, login to view] DATABASE_CONNECTION_STRING

'If the path to the database is not physical, map it.

isPhysicalPath = false

if Len(DATABASE_FILE_PATH) >= 3 then

if Mid(DATABASE_FILE_PATH, 2, 2) = ":\" then

isPhysicalPath = true

end if

end if

if not isPhysicalPath then

dbDir = [url removed, login to view](DATABASE_FILE_PATH)

else

dbDir = DATABASE_FILE_PATH

end if

if USE_ACCESS_ODBC_DRIVER then

[url removed, login to view] "DBQ="& dbDir & ";Driver={Microsoft Access Driver (*.mdb)}"

else

[url removed, login to view] "Data Source=" & dbDir & ";Provider=Microsoft.Jet.OLEDB.4.0;"

end if

end sub

the config file code is

'Location of the database.

const DATABASE_FILE_PATH = "./data/NFL.mdb"

'Database connection string (Can be Access or SQL Server).

'const DATABASE_CONNECTION_STRING = "Data Source=E:\web\survival\SFpool3\data\[url removed, login to view]; Provider=Microsoft.Jet.OLEDB.4.0;"

const DATABASE_CONNECTION_STRING = "Provider=SQLOLEDB;Data Source=tcp:[url removed, login to view];Initial Catalog=DB_26_nfl;User ID=DB_26 _nfl_user;Password=xxxxxxxx;Integrated Security=false;"

on the web the description of the error says that it is a data error, I used sql studio management to create the tables and there was no errors.

I attached the query that i ran to create the tables

Skills: Data Processing, SQL

See more: 80040e21 winhost, tcp global, string problem, sql server open source, open source sql, sql create database, map string, jet sql, common string, common query, sql microsoft access, microsoft access sql, survival, sql microsoft, sql data, sql code, sql access, open data, nfl, mdb, len, data tables, data source sql, data query, data operation

About the Employer:
( 0 reviews ) St-leonard, Canada

Project ID: #1144236

3 freelancers are bidding on average $45 for this job

shambo100

Please check PMB

$50 USD in 0 days
(2 Reviews)
3.9
terwelu

Please, attach common.asp file for my review. There is no wrong with query, but the ADODB operation

$50 USD in 0 days
(1 Review)
0.0
bhavesh77

Hi, i've more than 8 years of experience in software development after completing my MCA (master in computer application, full time 3 years post graduation course). I am expert in microsoft technologies. i've worked o More

$34 USD in 1 day
(0 Reviews)
0.0